<?php
include("include/connection.php");
$sql="select count(*) from user";
$members=mysql_query($sql);
$sql="select count(*) from video";
$videos=mysql_query($sql);
$sql="select count(*) from video where vid_state='pending'";
$new_videos=mysql_query($sql);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<link rel="stylesheet" href="css/style.css" type="text/css" >
<link rel="icon" type="image/png" href="images/restapp.png" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Admin</title>
</head>
<body>

	<div id='topmenu'>
		<div>
			<img style="float:left" src="images/logo.png" />
		</div>
		<ul>
				<li><a href="">Home</a></li>
				<li><a href="">Signup</a></li>
				<li><a href="">FAQ</a></li>
				<li><a href="">Contact</a></li>
		</ul>
	</div>

	<div id="limit">
<div id="user">
<h4><img src="images/loggedin.png" />User Account</h4>
<img id="image_profile" src="images/img_profile.png" />
<div id="info_user">
<h3>Hello Admin</h3>
<a href="">Modify your profile</a></div>
<!--#info_user--></div>
<!--#user-->
<div id="operations">
<ul>
	<h4>Categories</h4>
	<li><a href="profile.jsp"><img src="images/profile.png" />Profile</a>
	</li>
	<li><a href="training.jsp"><img src="images/video.png" />Videos</a>
	</li>
	</li>
	<li><a href="teachers.jsp"><img src="images/teacher.png" />Members</a>
	</li>
	<li><a href=""><img src="images/satatistiques.png" />Statistics</a>
	</li>
</ul>
</div>

<div id="page">
<h3>Statistics</h3>
Total Members : <?php while($total=mysql_fetch_array($members)) echo $total['0']; ?> <br />
Total New videos : <?php while($total=mysql_fetch_array($new_videos)) echo $total['0']; ?> <br />
Total videos : <?php while($total=mysql_fetch_array($videos)) echo $total['0']; ?>
				

</div>

<div id="copyrights"><span id="copytext">All rights reserved | Copyrights  2013 </span></div>

</div>



   		
</body>
</html>